package com.system.common.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BisBeautyRecordExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;
    protected String qcustomUserName;
    

	public String getQcustomUserName() {
		return qcustomUserName;
	}

	public void setQcustomUserName(String qcustomUserName) {
		this.qcustomUserName = qcustomUserName;
	}

	public BisBeautyRecordExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRecordIdIsNull() {
            addCriterion("record_id is null");
            return (Criteria) this;
        }

        public Criteria andRecordIdIsNotNull() {
            addCriterion("record_id is not null");
            return (Criteria) this;
        }

        public Criteria andRecordIdEqualTo(String value) {
            addCriterion("record_id =", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdNotEqualTo(String value) {
            addCriterion("record_id <>", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdGreaterThan(String value) {
            addCriterion("record_id >", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdGreaterThanOrEqualTo(String value) {
            addCriterion("record_id >=", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdLessThan(String value) {
            addCriterion("record_id <", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdLessThanOrEqualTo(String value) {
            addCriterion("record_id <=", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdLike(String value) {
            addCriterion("record_id like", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdNotLike(String value) {
            addCriterion("record_id not like", value, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdIn(List<String> values) {
            addCriterion("record_id in", values, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdNotIn(List<String> values) {
            addCriterion("record_id not in", values, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdBetween(String value1, String value2) {
            addCriterion("record_id between", value1, value2, "recordId");
            return (Criteria) this;
        }

        public Criteria andRecordIdNotBetween(String value1, String value2) {
            addCriterion("record_id not between", value1, value2, "recordId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andCdkeyIsNull() {
            addCriterion("cdkey is null");
            return (Criteria) this;
        }

        public Criteria andCdkeyIsNotNull() {
            addCriterion("cdkey is not null");
            return (Criteria) this;
        }

        public Criteria andCdkeyEqualTo(String value) {
            addCriterion("cdkey =", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyNotEqualTo(String value) {
            addCriterion("cdkey <>", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyGreaterThan(String value) {
            addCriterion("cdkey >", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyGreaterThanOrEqualTo(String value) {
            addCriterion("cdkey >=", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyLessThan(String value) {
            addCriterion("cdkey <", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyLessThanOrEqualTo(String value) {
            addCriterion("cdkey <=", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyLike(String value) {
            addCriterion("cdkey like", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyNotLike(String value) {
            addCriterion("cdkey not like", value, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyIn(List<String> values) {
            addCriterion("cdkey in", values, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyNotIn(List<String> values) {
            addCriterion("cdkey not in", values, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyBetween(String value1, String value2) {
            addCriterion("cdkey between", value1, value2, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCdkeyNotBetween(String value1, String value2) {
            addCriterion("cdkey not between", value1, value2, "cdkey");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdIsNull() {
            addCriterion("custom_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdIsNotNull() {
            addCriterion("custom_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdEqualTo(String value) {
            addCriterion("custom_user_id =", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdNotEqualTo(String value) {
            addCriterion("custom_user_id <>", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdGreaterThan(String value) {
            addCriterion("custom_user_id >", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("custom_user_id >=", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdLessThan(String value) {
            addCriterion("custom_user_id <", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdLessThanOrEqualTo(String value) {
            addCriterion("custom_user_id <=", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdLike(String value) {
            addCriterion("custom_user_id like", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdNotLike(String value) {
            addCriterion("custom_user_id not like", value, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdIn(List<String> values) {
            addCriterion("custom_user_id in", values, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdNotIn(List<String> values) {
            addCriterion("custom_user_id not in", values, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdBetween(String value1, String value2) {
            addCriterion("custom_user_id between", value1, value2, "customUserId");
            return (Criteria) this;
        }

        public Criteria andCustomUserIdNotBetween(String value1, String value2) {
            addCriterion("custom_user_id not between", value1, value2, "customUserId");
            return (Criteria) this;
        }

        public Criteria andBeautyNumIsNull() {
            addCriterion("beauty_num is null");
            return (Criteria) this;
        }

        public Criteria andBeautyNumIsNotNull() {
            addCriterion("beauty_num is not null");
            return (Criteria) this;
        }

        public Criteria andBeautyNumEqualTo(Integer value) {
            addCriterion("beauty_num =", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumNotEqualTo(Integer value) {
            addCriterion("beauty_num <>", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumGreaterThan(Integer value) {
            addCriterion("beauty_num >", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("beauty_num >=", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumLessThan(Integer value) {
            addCriterion("beauty_num <", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumLessThanOrEqualTo(Integer value) {
            addCriterion("beauty_num <=", value, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumIn(List<Integer> values) {
            addCriterion("beauty_num in", values, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumNotIn(List<Integer> values) {
            addCriterion("beauty_num not in", values, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumBetween(Integer value1, Integer value2) {
            addCriterion("beauty_num between", value1, value2, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andBeautyNumNotBetween(Integer value1, Integer value2) {
            addCriterion("beauty_num not between", value1, value2, "beautyNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumIsNull() {
            addCriterion("give_num is null");
            return (Criteria) this;
        }

        public Criteria andGiveNumIsNotNull() {
            addCriterion("give_num is not null");
            return (Criteria) this;
        }

        public Criteria andGiveNumEqualTo(Integer value) {
            addCriterion("give_num =", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumNotEqualTo(Integer value) {
            addCriterion("give_num <>", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumGreaterThan(Integer value) {
            addCriterion("give_num >", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("give_num >=", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumLessThan(Integer value) {
            addCriterion("give_num <", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumLessThanOrEqualTo(Integer value) {
            addCriterion("give_num <=", value, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumIn(List<Integer> values) {
            addCriterion("give_num in", values, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumNotIn(List<Integer> values) {
            addCriterion("give_num not in", values, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumBetween(Integer value1, Integer value2) {
            addCriterion("give_num between", value1, value2, "giveNum");
            return (Criteria) this;
        }

        public Criteria andGiveNumNotBetween(Integer value1, Integer value2) {
            addCriterion("give_num not between", value1, value2, "giveNum");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyIsNull() {
            addCriterion("total_money is null");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyIsNotNull() {
            addCriterion("total_money is not null");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyEqualTo(Double value) {
            addCriterion("total_money =", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyNotEqualTo(Double value) {
            addCriterion("total_money <>", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyGreaterThan(Double value) {
            addCriterion("total_money >", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("total_money >=", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyLessThan(Double value) {
            addCriterion("total_money <", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyLessThanOrEqualTo(Double value) {
            addCriterion("total_money <=", value, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyIn(List<Double> values) {
            addCriterion("total_money in", values, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyNotIn(List<Double> values) {
            addCriterion("total_money not in", values, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyBetween(Double value1, Double value2) {
            addCriterion("total_money between", value1, value2, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andTotalMoneyNotBetween(Double value1, Double value2) {
            addCriterion("total_money not between", value1, value2, "totalMoney");
            return (Criteria) this;
        }

        public Criteria andSingePriceIsNull() {
            addCriterion("singe_price is null");
            return (Criteria) this;
        }

        public Criteria andSingePriceIsNotNull() {
            addCriterion("singe_price is not null");
            return (Criteria) this;
        }

        public Criteria andSingePriceEqualTo(Double value) {
            addCriterion("singe_price =", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceNotEqualTo(Double value) {
            addCriterion("singe_price <>", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceGreaterThan(Double value) {
            addCriterion("singe_price >", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceGreaterThanOrEqualTo(Double value) {
            addCriterion("singe_price >=", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceLessThan(Double value) {
            addCriterion("singe_price <", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceLessThanOrEqualTo(Double value) {
            addCriterion("singe_price <=", value, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceIn(List<Double> values) {
            addCriterion("singe_price in", values, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceNotIn(List<Double> values) {
            addCriterion("singe_price not in", values, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceBetween(Double value1, Double value2) {
            addCriterion("singe_price between", value1, value2, "singePrice");
            return (Criteria) this;
        }

        public Criteria andSingePriceNotBetween(Double value1, Double value2) {
            addCriterion("singe_price not between", value1, value2, "singePrice");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIsNull() {
            addCriterion("record_type is null");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIsNotNull() {
            addCriterion("record_type is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTypeEqualTo(String value) {
            addCriterion("record_type =", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotEqualTo(String value) {
            addCriterion("record_type <>", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeGreaterThan(String value) {
            addCriterion("record_type >", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeGreaterThanOrEqualTo(String value) {
            addCriterion("record_type >=", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLessThan(String value) {
            addCriterion("record_type <", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLessThanOrEqualTo(String value) {
            addCriterion("record_type <=", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLike(String value) {
            addCriterion("record_type like", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotLike(String value) {
            addCriterion("record_type not like", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIn(List<String> values) {
            addCriterion("record_type in", values, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotIn(List<String> values) {
            addCriterion("record_type not in", values, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeBetween(String value1, String value2) {
            addCriterion("record_type between", value1, value2, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotBetween(String value1, String value2) {
            addCriterion("record_type not between", value1, value2, "recordType");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andVaildStatusIsNull() {
            addCriterion("vaild_status is null");
            return (Criteria) this;
        }

        public Criteria andVaildStatusIsNotNull() {
            addCriterion("vaild_status is not null");
            return (Criteria) this;
        }

        public Criteria andVaildStatusEqualTo(String value) {
            addCriterion("vaild_status =", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusNotEqualTo(String value) {
            addCriterion("vaild_status <>", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusGreaterThan(String value) {
            addCriterion("vaild_status >", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusGreaterThanOrEqualTo(String value) {
            addCriterion("vaild_status >=", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusLessThan(String value) {
            addCriterion("vaild_status <", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusLessThanOrEqualTo(String value) {
            addCriterion("vaild_status <=", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusLike(String value) {
            addCriterion("vaild_status like", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusNotLike(String value) {
            addCriterion("vaild_status not like", value, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusIn(List<String> values) {
            addCriterion("vaild_status in", values, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusNotIn(List<String> values) {
            addCriterion("vaild_status not in", values, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusBetween(String value1, String value2) {
            addCriterion("vaild_status between", value1, value2, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andVaildStatusNotBetween(String value1, String value2) {
            addCriterion("vaild_status not between", value1, value2, "vaildStatus");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNull() {
            addCriterion("shop_id is null");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNotNull() {
            addCriterion("shop_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopIdEqualTo(String value) {
            addCriterion("shop_id =", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotEqualTo(String value) {
            addCriterion("shop_id <>", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThan(String value) {
            addCriterion("shop_id >", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThanOrEqualTo(String value) {
            addCriterion("shop_id >=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThan(String value) {
            addCriterion("shop_id <", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThanOrEqualTo(String value) {
            addCriterion("shop_id <=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLike(String value) {
            addCriterion("shop_id like", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotLike(String value) {
            addCriterion("shop_id not like", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdIn(List<String> values) {
            addCriterion("shop_id in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotIn(List<String> values) {
            addCriterion("shop_id not in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdBetween(String value1, String value2) {
            addCriterion("shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotBetween(String value1, String value2) {
            addCriterion("shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andRemainNumIsNull() {
            addCriterion("remain_num is null");
            return (Criteria) this;
        }

        public Criteria andRemainNumIsNotNull() {
            addCriterion("remain_num is not null");
            return (Criteria) this;
        }

        public Criteria andRemainNumEqualTo(Integer value) {
            addCriterion("remain_num =", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumNotEqualTo(Integer value) {
            addCriterion("remain_num <>", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumGreaterThan(Integer value) {
            addCriterion("remain_num >", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("remain_num >=", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumLessThan(Integer value) {
            addCriterion("remain_num <", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumLessThanOrEqualTo(Integer value) {
            addCriterion("remain_num <=", value, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumIn(List<Integer> values) {
            addCriterion("remain_num in", values, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumNotIn(List<Integer> values) {
            addCriterion("remain_num not in", values, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumBetween(Integer value1, Integer value2) {
            addCriterion("remain_num between", value1, value2, "remainNum");
            return (Criteria) this;
        }

        public Criteria andRemainNumNotBetween(Integer value1, Integer value2) {
            addCriterion("remain_num not between", value1, value2, "remainNum");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}